<?php

class m120617_143204_create_bank extends EDbMigration {

	public function safeUp() {
		$columns = array(
			'id'=>'pk',
			'employeeId'=>'integer not null',
			'name'=>'varchar(64) not null',
			'branch'=>'varchar(128)',
			'code'=>'varchar(64)',
			'createdAt'=>'datetime',
			'updatedAt'=>'datetime',
			'createdBy'=>'integer',
			'updatedBy'=>'integer',
		);
		$this->createTable('banks', $columns);
	}

	public function safeDown() {
		$this->dropTable('banks');
	}

}